﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class ServiceItemDetailDAL_Const
    {
        public static readonly string SQL_SELECT_SERVICEITEMDETAIL = "SELECT * FROM SERVICEITEMDETAIL";

        public static readonly string SQL_DELETE_SERVICEITEMDETAIL = "DELETE FROM SERVICEITEMDETAIL WHERE SERVICEITEMID=@SERVICEITEMID";

        public static readonly string SQL_INSERT_SERVICEITEMDETAIL = "INSERT INTO SERVICEITEMDETAIL(SERVICEITEMID, SEQNUM, SDAYS, SMEMO) VALUES (@SERVICEITEMID, @SEQNUM, @SDAYS, @SMEMO)";

        public static readonly string SQL_UPDATE_SERVICEITEMDETAIL = "UPDATE SERVICEITEMDETAIL SET SERVICEITEMID=@SERVICEITEMID, SEQNUM=@SEQNUM, SDAYS=@SDAYS, SMEMO=@SMEMO WHERE SERVICEITEMDETAILID=@SERVICEITEMDETAILID";

        public static readonly string SQL_DELETE_SERVICEITEMDETAILBYID = "DELETE FROM SERVICEITEMDETAIL WHERE SERVICEITEMDETAILID=@SERVICEITEMDETAILID";
    }
}
